A Linear Programming Methodology to Optimize Decision-Making for Ready-Mixed Cement Products: a Case Study on Egypt’s New Administrative Capital

Egypt has started constructing its New Administrative Capital since 2015. The new capital was designed to meet smart city standards, which presents a challenge for businesses make the optimum business decisions given set budget such project. As result, reaching solution allocating needed materials each building became important. Many researchers have considered theory of constraints in their studies determine product mix. Frequently, research considers target profit maximization reach with one scenario. In this paper, we aim solve problem mix cement production, organizations face. formulated based on case study two linear programming approaches. For problem, many scenarios were presented under consideration aspects, are resource utilization and productivity. Data visualization used paper simplify procedure decision-making. Also, dashboard web application made decision makers it easier create, analyze, see different scenarios.